StudentRt4Calculation

EntityType | Independent
Logical Entity Name | StudentRt4Calculation
Default Table Name | SaReturnOfT4
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentRt4Calculation Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentRt4CalculationId |  | INTEGER | NO |
StudentId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
DropDate |  | DATETIME | NO |
CalculationDate |  | DATETIME | YES |
PeriodUsed |  | CHAR(1) | YES |
PeriodBeginDate |  | DATETIME | YES |
PeriodEndDate |  | DATETIME | YES |
AidDisbursed |  | MONEY(19, 4) | YES |
AidCouldHaveBeenDisbursed |  | MONEY(19, 4) | YES |
CompletedDays |  | INTEGER | YES |
TotalDays |  | INTEGER | YES |
CompletedHours |  | NUMERIC(9, 2) | YES |
TotalHours |  | NUMERIC(9, 2) | YES |
ScheduledHours |  | NUMERIC(9, 2) | YES |
PercentageTitleIvAidEarned |  | NUMERIC(5, 2) | YES |
AmountTitleIvAidEarned |  | MONEY(19, 4) | YES |
InstitutionalCharges |  | MONEY(19, 4) | YES |
AidToReturn |  | MONEY(19, 4) | YES |
AidToReturnSchool |  | MONEY(19, 4) | YES |
AidToReturnStudent |  | MONEY(19, 4) | YES |
PWDAmount |  | MONEY(19, 4) | YES |
PWDOutstandingCharge |  | MONEY(19, 4) | YES |
PWDTuitionCredit |  | MONEY(19, 4) | YES |
PWDOtherCredit |  | MONEY(19, 4) | YES |
PWDPriorYearCredit |  | MONEY(19, 4) | YES |
PWDCreditAuthorizationDate |  | DATETIME | YES |
PWDNotificationDate |  | DATETIME | YES |
PWDOfferNotificationDate |  | DATETIME | YES |
PwOfferNotificationResponseDate |  | DATETIME | YES |
PWDAmountOffered |  | MONEY(19, 4) | YES |
PWDAmountAccepted |  | MONEY(19, 4) | YES |
PWDAmountSentDate |  | DATETIME | YES |
TermId |  | INTEGER | YES |
StudentAcademicYearId |  | INTEGER | YES |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
LastModifiedUserId |  | INTEGER | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
ProgramType |  | CHAR(1) | NO |
IsAttendanceUsed |  | BIT | NO |
IsAidToReturnStudentIncluded |  | BIT | NO |
ProtectedTivAmount |  | MONEY(19, 4) | YES |
InitialTivAmountOwedByStudent |  | MONEY(19, 4) | YES |
RefundCalculationStatusId |  | INTEGER | YES |
RefundCalculationActionId |  | INTEGER | YES |
IsAutoApproved |  | BIT | NO |
ApprovedDate |  | DATETIME | YES |
EligibleChargeAccountBalance |  | MONEY(19, 4) | YES |
StudentAcademicYearPaymentPeriodId |  | INTEGER | YES |
StudentAcademicYearLoanPaymentPeriodId |  | INTEGER | YES |
StudentAcademicYearLoanPaymentPeriodId |  | INTEGER | YES |
StudentAcademicYearPaymentPeriodId |  | INTEGER | YES |

StudentRt4Calculation Keys

Key Name | Key Type | Keys
SaReturnOfT4_SaReturnOfT4ID_U_C_IDX | PrimaryKey | StudentRt4CalculationId
SaReturnofT4_FaStudentLPPaymentPeriodId_N_N_IDX | Inversion Entry | StudentAcademicYearLoanPaymentPeriodId
SaReturnofT4_FaStudentAyPaymentPeriodId_N_N_IDX | Inversion Entry | StudentAcademicYearPaymentPeriodId
SaReturnOfT4_AdEnrollID_DropDate_N_N_IDX | Inversion Entry | DropDate

StudentRt4Calculation Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearPaymentPeriodId | NO
StudentAcademicYearLoanPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearLoanPaymentPeriodId | NO
RefundCalculationAction | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundCalculationActionId | NO
RefundCalculationStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundCalculationStatusId | NO
RefundCalculationAction | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundCalculationActionId | NO
RefundCalculationStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundCalculationStatusId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentAcademicYear | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearId | NO
StudentAcademicYearLoanPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearLoanPaymentPeriodId | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearPaymentPeriodId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaReturnOfT4Assignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationPostWithdrawalDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaReturnOfT4StudentGroup_Faa | Non-Identifying | One To Zero or More |  |  |  |  | NO
Refund | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRefundCalculation | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationInstCharge | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationPostWithdrawalDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationStudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentRt4Calculation Check Constraints

Check Constraint Name | CheckConstraint

StudentRt4Calculation Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentRt4Calculation | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaReturnOfT4 | NO |  |  |

StudentRt4Calculation Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | RefundCalculation
Logical | Refunds_Stipends
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

StudentRt4Calculation Data Movement Rules

Name | Type | Rule Text/Value